//
//  DataBaseSingleton.h
//  豆瓣
//
//  Created by dllo on 15/11/4.
//  Copyright © 2015年 蓝鸥科技. All rights reserved.
//

#import <Foundation/Foundation.h>
#import "Activity.h"
#import "User.h"

@interface DataBaseSingleton : NSObject

+ (instancetype)shareDataBase;

- (void)openDB;

- (void)createActivityListTable;

- (void)insertActivityListSQL:(Activity *)activity;

- (NSMutableArray *)selectActivityList;

- (void)createUserListTable;

- (void)dropTable;

- (void)insertUserList:(User *)user;

- (NSMutableArray *)selectUserList;

- (NSMutableArray *)selectUserName;

- (NSMutableArray *)selectUserPasswd;

-(void)insertCollectList:(NSString *)title :(NSString *)name;

- (void)createCollectListTable;

- (NSMutableArray *)selectMovieName:(NSString *)UserName;

- (NSMutableArray *)selectActivityList:(NSString *)title;

- (void)deleteCollect:(NSString *)name :(NSString *)title;

@end
